SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and type ='T'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Condos page 25
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Gorgeous New Hampshire Lakefront! Wake up to breathtaking unobstructed views of Mascoma Lake in this beautifully situated Shaker Village home. Located across from the peaceful Shaker Museum walking grounds, this end-lot offers privacy while still being part of the sought-after Chosen Vale community. Outdoor enthusiasts will love the easy access to boating, swimming, ice fishing, skating, sledding, snowshoeing, hiking trails in the Lower Shaker Wildlife Management Area, and nearby skiing at Whaleback Mountain. This home boasts direct access to a dock slip and is just a short walk to two shared beaches. Additional features include heat pumps, Powerwall backup battery system, electric vehicle charger, and recently installed on-demand boiler. Conveniently located just 15–20 minutes from Dartmouth Hitchcock Medical Center, Dartmouth College, and White River Junction, this property offers the perfect balance of lakeside tranquility and accessibility. Open house Fri 7/10 3-5pm and Sat 7/11 10am-12pm
Description:This spacious four-bedroom, 3.5-bathroom Berrill Farms townhouse condominium features a versatile layout overlooking the pond. The main floor offers sun-filled spaces with hardwood floors, an open-concept living and dining area, a primary bedroom suite, a dedicated office, laundry, and a half bath. Upstairs, the second floor provides two additional bedrooms, a full bathroom, and a cozy socializing/TV area ideal for family or guests. Exceptional bonus space is found on the lower level, which includes a large multipurpose family room with a wood stove, a fourth bedroom, and another full bath. An attached two-car garage completes the property, which is conveniently located close to downtown Hanover, Dartmouth Hitchcock Medical Center, and local trail systems.